﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsLongPlan" targetNamespace="http://tempuri.org/dsLongPlan.xsd" xmlns:mstns="http://tempuri.org/dsLongPlan.xsd" xmlns="http://tempuri.org/dsLongPlan.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblRankTableAdapter" GeneratorDataComponentClassName="tblRankTableAdapter" Name="tblRank" UserDataComponentName="tblRankTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRank" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblRank] WHERE (([nRankId] = @Original_nRankId) AND ((@IsNull_cRankName = 1 AND [cRankName] IS NULL) OR ([cRankName] = @Original_cRankName)) AND ((@IsNull_nRankLevel = 1 AND [nRankLevel] IS NULL) OR ([nRankLevel] = @Original_nRankLevel)) AND ((@IsNull_cRankDescription = 1 AND [cRankDescription] IS NULL) OR ([cRankDescription] = @Original_cRankDescription)) AND ((@IsNull_iRankType = 1 AND [iRankType] IS NULL) OR ([iRankType] = @Original_iRankType)) AND ((@IsNull_BasicMonthlyWages = 1 AND [BasicMonthlyWages] IS NULL) OR ([BasicMonthlyWages] = @Original_BasicMonthlyWages)) AND ((@IsNull_Overtime_A = 1 AND [Overtime A] IS NULL) OR ([Overtime A] = @Original_Overtime_A)) AND ((@IsNull_Overtime_B = 1 AND [Overtime B] IS NULL) OR ([Overtime B] = @Original_Overtime_B)) AND ((@IsNull_SubsisAllowence = 1 AND [SubsisAllowence] IS NULL) OR ([SubsisAllowence] = @Original_SubsisAllowence)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BasicMonthlyWages" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_A" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_B" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SubsisAllowence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblRank] ([cRankName], [nRankLevel], [cRankDescription], [iRankType], [BasicMonthlyWages], [Overtime A], [Overtime B], [SubsisAllowence]) VALUES (@cRankName, @nRankLevel, @cRankDescription, @iRankType, @BasicMonthlyWages, @Overtime_A, @Overtime_B, @SubsisAllowence);
SELECT nRankId, cRankName, nRankLevel, cRankDescription, iRankType, BasicMonthlyWages, [Overtime A], [Overtime B], SubsisAllowence FROM tblRank WHERE (nRankId = SCOPE_IDENTITY()) ORDER BY nRankLevel</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nRankId, cRankName, nRankLevel, cRankDescription, iRankType, BasicMonthlyWages, [Overtime A], [Overtime B], SubsisAllowence
FROM            tblRank
ORDER BY nRankLevel</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblRank] SET [cRankName] = @cRankName, [nRankLevel] = @nRankLevel, [cRankDescription] = @cRankDescription, [iRankType] = @iRankType, [BasicMonthlyWages] = @BasicMonthlyWages, [Overtime A] = @Overtime_A, [Overtime B] = @Overtime_B, [SubsisAllowence] = @SubsisAllowence WHERE (([nRankId] = @Original_nRankId) AND ((@IsNull_cRankName = 1 AND [cRankName] IS NULL) OR ([cRankName] = @Original_cRankName)) AND ((@IsNull_nRankLevel = 1 AND [nRankLevel] IS NULL) OR ([nRankLevel] = @Original_nRankLevel)) AND ((@IsNull_cRankDescription = 1 AND [cRankDescription] IS NULL) OR ([cRankDescription] = @Original_cRankDescription)) AND ((@IsNull_iRankType = 1 AND [iRankType] IS NULL) OR ([iRankType] = @Original_iRankType)) AND ((@IsNull_BasicMonthlyWages = 1 AND [BasicMonthlyWages] IS NULL) OR ([BasicMonthlyWages] = @Original_BasicMonthlyWages)) AND ((@IsNull_Overtime_A = 1 AND [Overtime A] IS NULL) OR ([Overtime A] = @Original_Overtime_A)) AND ((@IsNull_Overtime_B = 1 AND [Overtime B] IS NULL) OR ([Overtime B] = @Original_Overtime_B)) AND ((@IsNull_SubsisAllowence = 1 AND [SubsisAllowence] IS NULL) OR ([SubsisAllowence] = @Original_SubsisAllowence)));
SELECT nRankId, cRankName, nRankLevel, cRankDescription, iRankType, BasicMonthlyWages, [Overtime A], [Overtime B], SubsisAllowence FROM tblRank WHERE (nRankId = @nRankId) ORDER BY nRankLevel</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BasicMonthlyWages" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_A" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_B" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SubsisAllowence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nRankId" ColumnName="nRankId" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nRankId" DataSetColumn="nRankId" />
              <Mapping SourceColumn="cRankName" DataSetColumn="cRankName" />
              <Mapping SourceColumn="nRankLevel" DataSetColumn="nRankLevel" />
              <Mapping SourceColumn="cRankDescription" DataSetColumn="cRankDescription" />
              <Mapping SourceColumn="iRankType" DataSetColumn="iRankType" />
              <Mapping SourceColumn="BasicMonthlyWages" DataSetColumn="BasicMonthlyWages" />
              <Mapping SourceColumn="Overtime A" DataSetColumn="Overtime A" />
              <Mapping SourceColumn="Overtime B" DataSetColumn="Overtime B" />
              <Mapping SourceColumn="SubsisAllowence" DataSetColumn="SubsisAllowence" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="MaxLevel" Modifier="Public" Name="MaxLevel" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="MaxLevel">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        MAX(nRankLevel) AS Expr1
FROM            tblRank
WHERE        (iRankType = @type)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="type" ColumnName="iRankType" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@type" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRank" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="returnRankLower" Modifier="Public" Name="returnRankLower" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="returnRankLower">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nRankId
FROM            tblRank
WHERE        (iRankType = @type) AND (nRankLevel = @level)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="type" ColumnName="iRankType" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@type" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="level" ColumnName="nRankLevel" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@level" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCrewTableAdapter" GeneratorDataComponentClassName="tblCrewTableAdapter" Name="tblCrew" UserDataComponentName="tblCrewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblCrew.nCrewId, tblCrew.nRankID, tblCrew.iCrewType, tblCrew.bImage, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblCrew.cCMT, 
                         tblCrew.cAddress, tblCrew.cHomeNo, tblCrew.cHandNo, tblAssignment.cStatus, tblCrew.dDateOfBirth, tblCrew.cMaritalStatus, tblCrew.cNationality, 
                         tblAssignment.isActive, tblAssignment.dDuKienRoiTau,DATEDIFF(mm, tblAssignment.dDuKienRoiTau, GETDATE()) AS onRest
FROM            tblCrew INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid
WHERE        (tblAssignment.cStatus = 'On Vacation' OR
                         tblAssignment.cStatus = 'New Crew') AND (tblAssignment.isActive = 1) OR
                         (tblAssignment.cStatus = 'On Board') AND (tblAssignment.isActive = 1) AND (DATEDIFF(month, tblAssignment.dDuKienRoiTau, GETDATE()) &gt;= 3)
ORDER BY tblAssignment.cStatus</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="iCrewType" DataSetColumn="iCrewType" />
              <Mapping SourceColumn="bImage" DataSetColumn="bImage" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cCMT" DataSetColumn="cCMT" />
              <Mapping SourceColumn="dDateOfBirth" DataSetColumn="dDateOfBirth" />
              <Mapping SourceColumn="cAddress" DataSetColumn="cAddress" />
              <Mapping SourceColumn="cHomeNo" DataSetColumn="cHomeNo" />
              <Mapping SourceColumn="cHandNo" DataSetColumn="cHandNo" />
              <Mapping SourceColumn="cMaritalStatus" DataSetColumn="cMaritalStatus" />
              <Mapping SourceColumn="cNationality" DataSetColumn="cNationality" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
              <Mapping SourceColumn="dDuKienRoiTau" DataSetColumn="dDuKienRoiTau" />
              <Mapping SourceColumn="onRest" DataSetColumn="onRest" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByAll" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByAll" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByAll">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblCrew.nCrewId, tblCrew.nRankID, tblCrew.iCrewType, tblCrew.bImage, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblCrew.cCMT, 
                         tblCrew.cAddress, tblCrew.cHomeNo, tblCrew.cHandNo, tblAssignment.cStatus, tblCrew.dDateOfBirth, tblCrew.cMaritalStatus, tblCrew.cNationality, 
                         tblAssignment.isActive, tblAssignment.dDuKienRoiTau, DATEDIFF(dd, tblAssignment.dDuKienRoiTau, @startdate) AS onRest, tblAssignment.dLeave, 
                         tblAssignment.nRequest, tblAssignment.cGhiChu, tblRank.nRankLevel
FROM            tblCrew INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId
WHERE        (tblAssignment.cStatus = 'On Vacation' OR
                         tblAssignment.cStatus = 'New Crew') AND (tblAssignment.isActive = 1) OR
                         (tblAssignment.cStatus = 'On Board') AND (tblAssignment.isActive = 1) AND (DATEDIFF(dd, tblAssignment.dDuKienRoiTau, @startdate) &gt;= 1)
ORDER BY tblRank.nRankLevel, onRest DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="startdate" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="DateTime" Direction="Input" ParameterName="@startdate" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByLevel" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByLevel" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByLevel">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblCrew.nCrewId, tblCrew.nRankID, tblCrew.iCrewType, tblCrew.bImage, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblCrew.cCMT, 
                         tblCrew.cAddress, tblCrew.cHomeNo, tblCrew.cHandNo, tblAssignment.cStatus, tblCrew.dDateOfBirth, tblCrew.cMaritalStatus, tblCrew.cNationality, 
                         tblAssignment.isActive, tblAssignment.dDuKienRoiTau, DATEDIFF(dd, tblAssignment.dDuKienRoiTau, @startdate) AS onRest, tblAssignment.dLeave, 
                         tblAssignment.nRequest, tblAssignment.cGhiChu, tblRank.nRankLevel
FROM            tblCrew INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId
WHERE        (tblAssignment.cStatus = 'On Vacation' OR
                         tblAssignment.cStatus = 'New Crew') AND (tblAssignment.isActive = 1) AND (tblRank.nRankLevel = @rank OR
                         tblRank.nRankLevel = @rankLower) OR
                         (tblAssignment.cStatus = 'On Board') AND (tblAssignment.isActive = 1) AND (DATEDIFF(dd, tblAssignment.dDuKienRoiTau, @startdate) &gt;= 1) AND 
                         (tblRank.nRankLevel = @rank OR
                         tblRank.nRankLevel = @rankLower)
ORDER BY onRest DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="startdate" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="DateTime" Direction="Input" ParameterName="@startdate" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="rank" ColumnName="nRankLevel" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@rank" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="rankLower" ColumnName="nRankLevel" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@rankLower" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByRank" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByRank" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByRank">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblCrew.nCrewId, tblCrew.nRankID, tblCrew.iCrewType, tblCrew.bImage, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblCrew.cCMT, 
                         tblCrew.cAddress, tblCrew.cHomeNo, tblCrew.cHandNo, tblAssignment.cStatus, tblCrew.dDateOfBirth, tblCrew.cMaritalStatus, tblCrew.cNationality, 
                         tblAssignment.isActive, tblAssignment.dDuKienRoiTau, DATEDIFF(dd, tblAssignment.dDuKienRoiTau, @startdate) AS onRest, tblAssignment.dLeave, 
                         tblAssignment.nRequest, tblAssignment.cGhiChu
FROM            tblCrew INNER JOIN
                         tblAssignment ON tblCrew.nCrewId = tblAssignment.nCrewid
WHERE        (tblAssignment.cStatus = 'On Vacation' OR
                         tblAssignment.cStatus = 'New Crew') AND (tblAssignment.isActive = 1) AND (tblCrew.nRankID = @rank OR
                         tblCrew.nRankID = @rankLower) OR
                         (tblAssignment.cStatus = 'On Board') AND (tblAssignment.isActive = 1) AND (tblCrew.nRankID = @rank OR
                         tblCrew.nRankID = @rankLower) AND (DATEDIFF(dd, tblAssignment.dDuKienRoiTau, @startdate) &gt;= 1)
ORDER BY DATEDIFF(dd, tblAssignment.dDuKienRoiTau, @startdate) DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="startdate" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="DateTime" Direction="Input" ParameterName="@startdate" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="rank" ColumnName="nRankID" DataSourceName="CrewManagment.dbo.tblCrew" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@rank" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="rankLower" ColumnName="nRankID" DataSourceName="CrewManagment.dbo.tblCrew" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@rankLower" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblVesselTableAdapter" GeneratorDataComponentClassName="tblVesselTableAdapter" Name="tblVessel" UserDataComponentName="tblVesselTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblVessel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblVessel] WHERE (([nVesselId] = @Original_nVesselId) AND ((@IsNull_nEngineType = 1 AND [nEngineType] IS NULL) OR ([nEngineType] = @Original_nEngineType)) AND ((@IsNull_nEngineMaker = 1 AND [nEngineMaker] IS NULL) OR ([nEngineMaker] = @Original_nEngineMaker)) AND ((@IsNull_fHorsePower = 1 AND [fHorsePower] IS NULL) OR ([fHorsePower] = @Original_fHorsePower)) AND ((@IsNull_cVesselName = 1 AND [cVesselName] IS NULL) OR ([cVesselName] = @Original_cVesselName)) AND ((@IsNull_cShortName = 1 AND [cShortName] IS NULL) OR ([cShortName] = @Original_cShortName)) AND ((@IsNull_nGroupId = 1 AND [nGroupId] IS NULL) OR ([nGroupId] = @Original_nGroupId)) AND ((@IsNull_nFlagId = 1 AND [nFlagId] IS NULL) OR ([nFlagId] = @Original_nFlagId)) AND ((@IsNull_nVesselTypeId = 1 AND [nVesselTypeId] IS NULL) OR ([nVesselTypeId] = @Original_nVesselTypeId)) AND ((@IsNull_fGRT = 1 AND [fGRT] IS NULL) OR ([fGRT] = @Original_fGRT)) AND ((@IsNull_cImoNumber = 1 AND [cImoNumber] IS NULL) OR ([cImoNumber] = @Original_cImoNumber)) AND ((@IsNull_cPortOfRegistry = 1 AND [cPortOfRegistry] IS NULL) OR ([cPortOfRegistry] = @Original_cPortOfRegistry)) AND ((@IsNull_dYearBuilt = 1 AND [dYearBuilt] IS NULL) OR ([dYearBuilt] = @Original_dYearBuilt)) AND ((@IsNull_cVesselManaged = 1 AND [cVesselManaged] IS NULL) OR ([cVesselManaged] = @Original_cVesselManaged)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHorsePower" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fGRT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cImoNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPortOfRegistry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dYearBuilt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselManaged" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselManaged" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblVessel] ([nEngineType], [nEngineMaker], [fHorsePower], [cVesselName], [cShortName], [nGroupId], [nFlagId], [nVesselTypeId], [fGRT], [cTradeArea], [cImoNumber], [cPortOfRegistry], [dYearBuilt], [cVesselManaged]) VALUES (@nEngineType, @nEngineMaker, @fHorsePower, @cVesselName, @cShortName, @nGroupId, @nFlagId, @nVesselTypeId, @fGRT, @cTradeArea, @cImoNumber, @cPortOfRegistry, @dYearBuilt, @cVesselManaged);
SELECT nVesselId, nEngineType, nEngineMaker, fHorsePower, cVesselName, cShortName, nGroupId, nFlagId, nVesselTypeId, fGRT, cTradeArea, cImoNumber, cPortOfRegistry, dYearBuilt, cVesselManaged FROM tblVessel WHERE (nVesselId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTradeArea" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTradeArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselManaged" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nVesselId, nEngineType, nEngineMaker, fHorsePower, cVesselName, cShortName, nGroupId, nFlagId, nVesselTypeId, fGRT, cTradeArea, cImoNumber, 
                         cPortOfRegistry, dYearBuilt, cVesselManaged
FROM            tblVessel
WHERE        (cVesselManaged = 'Managed')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblVessel] SET [nEngineType] = @nEngineType, [nEngineMaker] = @nEngineMaker, [fHorsePower] = @fHorsePower, [cVesselName] = @cVesselName, [cShortName] = @cShortName, [nGroupId] = @nGroupId, [nFlagId] = @nFlagId, [nVesselTypeId] = @nVesselTypeId, [fGRT] = @fGRT, [cTradeArea] = @cTradeArea, [cImoNumber] = @cImoNumber, [cPortOfRegistry] = @cPortOfRegistry, [dYearBuilt] = @dYearBuilt, [cVesselManaged] = @cVesselManaged WHERE (([nVesselId] = @Original_nVesselId) AND ((@IsNull_nEngineType = 1 AND [nEngineType] IS NULL) OR ([nEngineType] = @Original_nEngineType)) AND ((@IsNull_nEngineMaker = 1 AND [nEngineMaker] IS NULL) OR ([nEngineMaker] = @Original_nEngineMaker)) AND ((@IsNull_fHorsePower = 1 AND [fHorsePower] IS NULL) OR ([fHorsePower] = @Original_fHorsePower)) AND ((@IsNull_cVesselName = 1 AND [cVesselName] IS NULL) OR ([cVesselName] = @Original_cVesselName)) AND ((@IsNull_cShortName = 1 AND [cShortName] IS NULL) OR ([cShortName] = @Original_cShortName)) AND ((@IsNull_nGroupId = 1 AND [nGroupId] IS NULL) OR ([nGroupId] = @Original_nGroupId)) AND ((@IsNull_nFlagId = 1 AND [nFlagId] IS NULL) OR ([nFlagId] = @Original_nFlagId)) AND ((@IsNull_nVesselTypeId = 1 AND [nVesselTypeId] IS NULL) OR ([nVesselTypeId] = @Original_nVesselTypeId)) AND ((@IsNull_fGRT = 1 AND [fGRT] IS NULL) OR ([fGRT] = @Original_fGRT)) AND ((@IsNull_cImoNumber = 1 AND [cImoNumber] IS NULL) OR ([cImoNumber] = @Original_cImoNumber)) AND ((@IsNull_cPortOfRegistry = 1 AND [cPortOfRegistry] IS NULL) OR ([cPortOfRegistry] = @Original_cPortOfRegistry)) AND ((@IsNull_dYearBuilt = 1 AND [dYearBuilt] IS NULL) OR ([dYearBuilt] = @Original_dYearBuilt)) AND ((@IsNull_cVesselManaged = 1 AND [cVesselManaged] IS NULL) OR ([cVesselManaged] = @Original_cVesselManaged)));
SELECT nVesselId, nEngineType, nEngineMaker, fHorsePower, cVesselName, cShortName, nGroupId, nFlagId, nVesselTypeId, fGRT, cTradeArea, cImoNumber, cPortOfRegistry, dYearBuilt, cVesselManaged FROM tblVessel WHERE (nVesselId = @nVesselId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTradeArea" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTradeArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselManaged" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHorsePower" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fGRT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cImoNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPortOfRegistry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dYearBuilt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselManaged" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselManaged" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselManaged" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nVesselId" ColumnName="nVesselId" DataSourceName="CrewManagment.dbo.tblVessel" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="nEngineType" DataSetColumn="nEngineType" />
              <Mapping SourceColumn="nEngineMaker" DataSetColumn="nEngineMaker" />
              <Mapping SourceColumn="fHorsePower" DataSetColumn="fHorsePower" />
              <Mapping SourceColumn="cVesselName" DataSetColumn="cVesselName" />
              <Mapping SourceColumn="cShortName" DataSetColumn="cShortName" />
              <Mapping SourceColumn="nGroupId" DataSetColumn="nGroupId" />
              <Mapping SourceColumn="nFlagId" DataSetColumn="nFlagId" />
              <Mapping SourceColumn="nVesselTypeId" DataSetColumn="nVesselTypeId" />
              <Mapping SourceColumn="fGRT" DataSetColumn="fGRT" />
              <Mapping SourceColumn="cTradeArea" DataSetColumn="cTradeArea" />
              <Mapping SourceColumn="cImoNumber" DataSetColumn="cImoNumber" />
              <Mapping SourceColumn="cPortOfRegistry" DataSetColumn="cPortOfRegistry" />
              <Mapping SourceColumn="dYearBuilt" DataSetColumn="dYearBuilt" />
              <Mapping SourceColumn="cVesselManaged" DataSetColumn="cVesselManaged" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblLongPlanVesselTableAdapter" GeneratorDataComponentClassName="tblLongPlanVesselTableAdapter" Name="tblLongPlanVessel" UserDataComponentName="tblLongPlanVesselTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblLongPlanVessel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblLongPlanVessel] WHERE (([nLongPlanVesselId] = @Original_nLongPlanVesselId) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_nCrewId = 1 AND [nCrewId] IS NULL) OR ([nCrewId] = @Original_nCrewId)) AND ((@IsNull_VesselName = 1 AND [VesselName] IS NULL) OR ([VesselName] = @Original_VesselName)) AND ((@IsNull_FullName = 1 AND [FullName] IS NULL) OR ([FullName] = @Original_FullName)) AND ((@IsNull_ShortName = 1 AND [ShortName] IS NULL) OR ([ShortName] = @Original_ShortName)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_dStart = 1 AND [dStart] IS NULL) OR ([dStart] = @Original_dStart)) AND ((@IsNull_dEnd = 1 AND [dEnd] IS NULL) OR ([dEnd] = @Original_dEnd)) AND ((@IsNull_nRankId = 1 AND [nRankId] IS NULL) OR ([nRankId] = @Original_nRankId)) AND ((@IsNull_PlanID = 1 AND [PlanID] IS NULL) OR ([PlanID] = @Original_PlanID)) AND ((@IsNull_Subject = 1 AND [Subject] IS NULL) OR ([Subject] = @Original_Subject)) AND ((@IsNull_GroupName = 1 AND [GroupName] IS NULL) OR ([GroupName] = @Original_GroupName)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nLongPlanVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nLongPlanVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Subject" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GroupName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GroupName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GroupName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GroupName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblLongPlanVessel] ([nVesselId], [nCrewId], [VesselName], [FullName], [ShortName], [nContract], [dStart], [dEnd], [nRankId], [PlanID], [Subject], [GroupName]) VALUES (@nVesselId, @nCrewId, @VesselName, @FullName, @ShortName, @nContract, @dStart, @dEnd, @nRankId, @PlanID, @Subject, @GroupName);
SELECT nLongPlanVesselId, nVesselId, nCrewId, VesselName, FullName, ShortName, nContract, dStart, dEnd, nRankId, PlanID, Subject, GroupName FROM tblLongPlanVessel WHERE (nLongPlanVesselId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GroupName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GroupName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nLongPlanVesselId, nVesselId, nCrewId, VesselName, FullName, ShortName, nContract, dStart, dEnd, nRankId, PlanID, Subject, GroupName
FROM            tblLongPlanVessel</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblLongPlanVessel] SET [nVesselId] = @nVesselId, [nCrewId] = @nCrewId, [VesselName] = @VesselName, [FullName] = @FullName, [ShortName] = @ShortName, [nContract] = @nContract, [dStart] = @dStart, [dEnd] = @dEnd, [nRankId] = @nRankId, [PlanID] = @PlanID, [Subject] = @Subject, [GroupName] = @GroupName WHERE (([nLongPlanVesselId] = @Original_nLongPlanVesselId) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_nCrewId = 1 AND [nCrewId] IS NULL) OR ([nCrewId] = @Original_nCrewId)) AND ((@IsNull_VesselName = 1 AND [VesselName] IS NULL) OR ([VesselName] = @Original_VesselName)) AND ((@IsNull_FullName = 1 AND [FullName] IS NULL) OR ([FullName] = @Original_FullName)) AND ((@IsNull_ShortName = 1 AND [ShortName] IS NULL) OR ([ShortName] = @Original_ShortName)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_dStart = 1 AND [dStart] IS NULL) OR ([dStart] = @Original_dStart)) AND ((@IsNull_dEnd = 1 AND [dEnd] IS NULL) OR ([dEnd] = @Original_dEnd)) AND ((@IsNull_nRankId = 1 AND [nRankId] IS NULL) OR ([nRankId] = @Original_nRankId)) AND ((@IsNull_PlanID = 1 AND [PlanID] IS NULL) OR ([PlanID] = @Original_PlanID)) AND ((@IsNull_Subject = 1 AND [Subject] IS NULL) OR ([Subject] = @Original_Subject)) AND ((@IsNull_GroupName = 1 AND [GroupName] IS NULL) OR ([GroupName] = @Original_GroupName)));
SELECT nLongPlanVesselId, nVesselId, nCrewId, VesselName, FullName, ShortName, nContract, dStart, dEnd, nRankId, PlanID, Subject, GroupName FROM tblLongPlanVessel WHERE (nLongPlanVesselId = @nLongPlanVesselId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GroupName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GroupName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nLongPlanVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nLongPlanVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PlanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Subject" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GroupName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GroupName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GroupName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GroupName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nLongPlanVesselId" ColumnName="nLongPlanVesselId" DataSourceName="CrewManagment.dbo.tblLongPlanVessel" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nLongPlanVesselId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nLongPlanVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nLongPlanVesselId" DataSetColumn="nLongPlanVesselId" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="VesselName" DataSetColumn="VesselName" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="dStart" DataSetColumn="dStart" />
              <Mapping SourceColumn="dEnd" DataSetColumn="dEnd" />
              <Mapping SourceColumn="nRankId" DataSetColumn="nRankId" />
              <Mapping SourceColumn="PlanID" DataSetColumn="PlanID" />
              <Mapping SourceColumn="ShortName" DataSetColumn="ShortName" />
              <Mapping SourceColumn="nContract" DataSetColumn="nContract" />
              <Mapping SourceColumn="Subject" DataSetColumn="Subject" />
              <Mapping SourceColumn="GroupName" DataSetColumn="GroupName" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblLongPlanVessel" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="CheckConflictCrew" GeneratorSourceName="CheckOverLoad" GetMethodModifier="Public" GetMethodName="CheckConflictCrew" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="CheckConflictCrew" UserSourceName="CheckConflictCrew">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FullName, GroupName, PlanID, ShortName, Subject, VesselName, dEnd, dStart, nContract, nCrewId, nLongPlanVesselId, nRankId, nVesselId FROM tblLongPlanVessel WHERE (dStart BETWEEN @start AND @end) AND (nCrewId = @id) OR (nCrewId = @id) AND (dEnd BETWEEN @start AND @end) OR (dStart &gt;= @start) AND (nCrewId = @id) AND (dEnd &lt;= @end) OR (dStart &lt;= @start) AND (nCrewId = @id) AND (dEnd &gt;= @end)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="start" ColumnName="dStart" DataSourceName="CrewManagment.dbo.tblLongPlanVessel" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@start" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="end" ColumnName="dStart" DataSourceName="CrewManagment.dbo.tblLongPlanVessel" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@end" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="dStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="id" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblLongPlanVessel" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblLongPlanVessel" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="CheckIfVacationMonthLessThan3" GetMethodModifier="Public" GetMethodName="CheckIfVacationMonthLessThan3" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="CheckIfVacationMonthLessThan3" UserSourceName="CheckIfVacationMonthLessThan3">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FullName, GroupName, PlanID, ShortName, Subject, VesselName, dEnd, dStart, nContract, nCrewId, nLongPlanVesselId, nRankId, nVesselId FROM tblLongPlanVessel WHERE (DATEDIFF(month, @end, dStart) BETWEEN 0 AND 3 OR DATEDIFF(month, dEnd, @start) BETWEEN 0 AND 3) AND (nCrewId = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="end" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="DateTime" Direction="Input" ParameterName="@end" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="start" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="DateTime" Direction="Input" ParameterName="@start" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="id" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblLongPlanVessel" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblLongPlanVessel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FullName, GroupName, PlanID, ShortName, Subject, VesselName, dEnd, dStart, nContract, nCrewId, nLongPlanVesselId, nRankId, nVesselId FROM tblLongPlanVessel WHERE (PlanID = @PlanID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PlanID" ColumnName="PlanID" DataSourceName="CrewManagment.dbo.tblLongPlanVessel" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PlanID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PlanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblKeHoachTableAdapter" GeneratorDataComponentClassName="tblKeHoachTableAdapter" Name="tblKeHoach" UserDataComponentName="tblKeHoachTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblKeHoach" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblKeHoach] WHERE (([Planid] = @Original_Planid) AND ((@IsNull_Tên_kế_hoạch = 1 AND [Tên kế hoạch] IS NULL) OR ([Tên kế hoạch] = @Original_Tên_kế_hoạch)) AND ((@IsNull_Người_lập_kế_hoạch = 1 AND [Người lập kế hoạch] IS NULL) OR ([Người lập kế hoạch] = @Original_Người_lập_kế_hoạch)) AND ((@IsNull_Ngày_lập_kế_hoạch = 1 AND [Ngày lập kế hoạch] IS NULL) OR ([Ngày lập kế hoạch] = @Original_Ngày_lập_kế_hoạch)) AND ((@IsNull_Ngày_chỉnh_sửa = 1 AND [Ngày chỉnh sửa] IS NULL) OR ([Ngày chỉnh sửa] = @Original_Ngày_chỉnh_sửa)) AND ((@IsNull_isLongPlan = 1 AND [isLongPlan] IS NULL) OR ([isLongPlan] = @Original_isLongPlan)) AND ((@IsNull_Từ = 1 AND [Từ] IS NULL) OR ([Từ] = @Original_Từ)) AND ((@IsNull_Đến = 1 AND [Đến] IS NULL) OR ([Đến] = @Original_Đến)) AND ((@IsNull_Đã_duyệt = 1 AND [Đã duyệt] IS NULL) OR ([Đã duyệt] = @Original_Đã_duyệt)) AND ((@IsNull_isDone = 1 AND [isDone] IS NULL) OR ([isDone] = @Original_isDone)) AND ((@IsNull_NguoiChinhSua = 1 AND [NguoiChinhSua] IS NULL) OR ([NguoiChinhSua] = @Original_NguoiChinhSua)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Planid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tên_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tên_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Người_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Ngày_lập_kế_hoạch" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày_chỉnh_sửa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Ngày_chỉnh_sửa" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isLongPlan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isLongPlan" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Từ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Từ" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đến" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Đến" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đã_duyệt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Đã_duyệt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NguoiChinhSua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NguoiChinhSua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblKeHoach] ([Tên kế hoạch], [Người lập kế hoạch], [Ngày lập kế hoạch], [Ngày chỉnh sửa], [isLongPlan], [Mô tả], [Từ], [Đến], [Đã duyệt], [isDone], [NguoiChinhSua]) VALUES (@Tên_kế_hoạch, @Người_lập_kế_hoạch, @Ngày_lập_kế_hoạch, @Ngày_chỉnh_sửa, @isLongPlan, @Mô_tả, @Từ, @Đến, @Đã_duyệt, @isDone, @NguoiChinhSua);
SELECT Planid, [Tên kế hoạch], [Người lập kế hoạch], [Ngày lập kế hoạch], [Ngày chỉnh sửa], isLongPlan, [Mô tả], Từ, Đến, [Đã duyệt], isDone, NguoiChinhSua FROM tblKeHoach WHERE (Planid = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tên_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Ngày_lập_kế_hoạch" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Ngày_chỉnh_sửa" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isLongPlan" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mô_tả" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mô tả" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Từ" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Đến" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Đã_duyệt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NguoiChinhSua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Planid, [Tên kế hoạch], [Người lập kế hoạch], [Ngày lập kế hoạch], [Ngày chỉnh sửa], isLongPlan, [Mô tả], Từ, Đến, [Đã duyệt], isDone, NguoiChinhSua
FROM            tblKeHoach</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblKeHoach] SET [Tên kế hoạch] = @Tên_kế_hoạch, [Người lập kế hoạch] = @Người_lập_kế_hoạch, [Ngày lập kế hoạch] = @Ngày_lập_kế_hoạch, [Ngày chỉnh sửa] = @Ngày_chỉnh_sửa, [isLongPlan] = @isLongPlan, [Mô tả] = @Mô_tả, [Từ] = @Từ, [Đến] = @Đến, [Đã duyệt] = @Đã_duyệt, [isDone] = @isDone, [NguoiChinhSua] = @NguoiChinhSua WHERE (([Planid] = @Original_Planid) AND ((@IsNull_Tên_kế_hoạch = 1 AND [Tên kế hoạch] IS NULL) OR ([Tên kế hoạch] = @Original_Tên_kế_hoạch)) AND ((@IsNull_Người_lập_kế_hoạch = 1 AND [Người lập kế hoạch] IS NULL) OR ([Người lập kế hoạch] = @Original_Người_lập_kế_hoạch)) AND ((@IsNull_Ngày_lập_kế_hoạch = 1 AND [Ngày lập kế hoạch] IS NULL) OR ([Ngày lập kế hoạch] = @Original_Ngày_lập_kế_hoạch)) AND ((@IsNull_Ngày_chỉnh_sửa = 1 AND [Ngày chỉnh sửa] IS NULL) OR ([Ngày chỉnh sửa] = @Original_Ngày_chỉnh_sửa)) AND ((@IsNull_isLongPlan = 1 AND [isLongPlan] IS NULL) OR ([isLongPlan] = @Original_isLongPlan)) AND ((@IsNull_Từ = 1 AND [Từ] IS NULL) OR ([Từ] = @Original_Từ)) AND ((@IsNull_Đến = 1 AND [Đến] IS NULL) OR ([Đến] = @Original_Đến)) AND ((@IsNull_Đã_duyệt = 1 AND [Đã duyệt] IS NULL) OR ([Đã duyệt] = @Original_Đã_duyệt)) AND ((@IsNull_isDone = 1 AND [isDone] IS NULL) OR ([isDone] = @Original_isDone)) AND ((@IsNull_NguoiChinhSua = 1 AND [NguoiChinhSua] IS NULL) OR ([NguoiChinhSua] = @Original_NguoiChinhSua)));
SELECT Planid, [Tên kế hoạch], [Người lập kế hoạch], [Ngày lập kế hoạch], [Ngày chỉnh sửa], isLongPlan, [Mô tả], Từ, Đến, [Đã duyệt], isDone, NguoiChinhSua FROM tblKeHoach WHERE (Planid = @Planid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tên_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Ngày_lập_kế_hoạch" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Ngày_chỉnh_sửa" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isLongPlan" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mô_tả" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mô tả" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Từ" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Đến" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Đã_duyệt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NguoiChinhSua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Planid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tên_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tên_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tên kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Người_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Ngày_lập_kế_hoạch" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Ngày lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày_chỉnh_sửa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Ngày_chỉnh_sửa" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Ngày chỉnh sửa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isLongPlan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isLongPlan" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isLongPlan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Từ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Từ" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Từ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đến" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Đến" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Đến" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đã_duyệt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Đã_duyệt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã duyệt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDone" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NguoiChinhSua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NguoiChinhSua" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguoiChinhSua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Planid" ColumnName="Planid" DataSourceName="CrewManagment.dbo.tblKeHoach" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Planid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Planid" DataSetColumn="Planid" />
              <Mapping SourceColumn="Tên kế hoạch" DataSetColumn="Tên kế hoạch" />
              <Mapping SourceColumn="Người lập kế hoạch" DataSetColumn="Người lập kế hoạch" />
              <Mapping SourceColumn="Ngày lập kế hoạch" DataSetColumn="Ngày lập kế hoạch" />
              <Mapping SourceColumn="Ngày chỉnh sửa" DataSetColumn="Ngày chỉnh sửa" />
              <Mapping SourceColumn="isLongPlan" DataSetColumn="isLongPlan" />
              <Mapping SourceColumn="Mô tả" DataSetColumn="Mô tả" />
              <Mapping SourceColumn="Từ" DataSetColumn="Từ" />
              <Mapping SourceColumn="Đến" DataSetColumn="Đến" />
              <Mapping SourceColumn="Đã duyệt" DataSetColumn="Đã duyệt" />
              <Mapping SourceColumn="isDone" DataSetColumn="isDone" />
              <Mapping SourceColumn="NguoiChinhSua" DataSetColumn="NguoiChinhSua" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteKeHoach" Modifier="Public" Name="DeleteKeHoach" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteKeHoach">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [tblKeHoach] WHERE Planid = @Planid</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Planid" ColumnName="Planid" DataSourceName="CrewManagment.dbo.tblKeHoach" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Planid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblKeHoach" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [Mô tả], NguoiChinhSua, [Ngày chỉnh sửa], [Ngày lập kế hoạch], [Người lập kế hoạch], Planid, [Tên kế hoạch], Từ, isDone, isLongPlan, [Đã duyệt], Đến FROM tblKeHoach WHERE (Planid = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="Planid" DataSourceName="CrewManagment.dbo.tblKeHoach" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Planid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblKeHoach" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLongPlan" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByLongPlan" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByLongPlan">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [Mô tả], NguoiChinhSua, [Ngày chỉnh sửa], [Ngày lập kế hoạch], [Người lập kế hoạch], Planid, [Tên kế hoạch], Từ, isDone, isLongPlan, [Đã duyệt], Đến FROM tblKeHoach WHERE (isLongPlan = @long)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="long" ColumnName="isLongPlan" DataSourceName="CrewManagment.dbo.tblKeHoach" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@long" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="isLongPlan" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="NextID" Modifier="Public" Name="NextID" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="NextID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDENT_CURRENT('tblKeHoach') + IDENT_INCR('tblKeHoach')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblAssignmentTableAdapter" GeneratorDataComponentClassName="tblAssignmentTableAdapter" Name="tblAssignment" UserDataComponentName="tblAssignmentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblAssignment.nAssignmentId, tblAssignment.nCrewid, tblAssignment.nVesselId, tblAssignment.cStatus, tblAssignment.cDescription, tblAssignment.dEmbarked, 
                         tblAssignment.nContract, tblAssignment.dLeave, tblAssignment.nRequest, tblAssignment.dDuKienRoiTau, tblAssignment.dSanSangLenTau, 
                         tblAssignment.dCatHopDong, tblAssignment.dNghiHuu, tblAssignment.dKyHopDong, tblAssignment.dModified, tblAssignment.isActive, tblAssignment.cGhiChu, 
                         tblCrew.nRankID
FROM            tblAssignment INNER JOIN
                         tblCrew ON tblAssignment.nCrewid = tblCrew.nCrewId
WHERE        (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = 'On Board')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nAssignmentId" DataSetColumn="nAssignmentId" />
              <Mapping SourceColumn="nCrewid" DataSetColumn="nCrewid" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
              <Mapping SourceColumn="dEmbarked" DataSetColumn="dEmbarked" />
              <Mapping SourceColumn="nContract" DataSetColumn="nContract" />
              <Mapping SourceColumn="dLeave" DataSetColumn="dLeave" />
              <Mapping SourceColumn="nRequest" DataSetColumn="nRequest" />
              <Mapping SourceColumn="dDuKienRoiTau" DataSetColumn="dDuKienRoiTau" />
              <Mapping SourceColumn="dSanSangLenTau" DataSetColumn="dSanSangLenTau" />
              <Mapping SourceColumn="dCatHopDong" DataSetColumn="dCatHopDong" />
              <Mapping SourceColumn="dNghiHuu" DataSetColumn="dNghiHuu" />
              <Mapping SourceColumn="dKyHopDong" DataSetColumn="dKyHopDong" />
              <Mapping SourceColumn="dModified" DataSetColumn="dModified" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
              <Mapping SourceColumn="cGhiChu" DataSetColumn="cGhiChu" />
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblColorTableAdapter" GeneratorDataComponentClassName="tblColorTableAdapter" Name="tblColor" UserDataComponentName="tblColorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblColor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select * from tblColor</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblVesselGroupTableAdapter" GeneratorDataComponentClassName="tblVesselGroupTableAdapter" Name="tblVesselGroup" UserDataComponentName="tblVesselGroupTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblVesselGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblVesselGroup] WHERE (([nGroupId] = @Original_nGroupId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblVesselGroup] ([cGroupName], [cDescription]) VALUES (@cGroupName, @cDescription);
SELECT nGroupId, cGroupName, cDescription FROM tblVesselGroup WHERE (nGroupId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cGroupName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGroupName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblVesselGroup.*
FROM            tblVesselGroup</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblVesselGroup] SET [cGroupName] = @cGroupName, [cDescription] = @cDescription WHERE (([nGroupId] = @Original_nGroupId));
SELECT nGroupId, cGroupName, cDescription FROM tblVesselGroup WHERE (nGroupId = @nGroupId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cGroupName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGroupName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nGroupId" ColumnName="nGroupId" DataSourceName="CrewManagment.dbo.tblVesselGroup" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nGroupId" DataSetColumn="nGroupId" />
              <Mapping SourceColumn="cGroupName" DataSetColumn="cGroupName" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsLongPlan" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsLongPlan" msprop:Generator_UserDSName="dsLongPlan">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblRank" msprop:Generator_TableClassName="tblRankDataTable" msprop:Generator_TableVarName="tabletblRank" msprop:Generator_TablePropName="tblRank" msprop:Generator_RowDeletingName="tblRankRowDeleting" msprop:Generator_UserTableName="tblRank" msprop:Generator_RowChangingName="tblRankRowChanging" msprop:Generator_RowEvHandlerName="tblRankRowChangeEventHandler" msprop:Generator_RowDeletedName="tblRankRowDeleted" msprop:Generator_RowEvArgName="tblRankRowChangeEvent" msprop:Generator_RowChangedName="tblRankRowChanged" msprop:Generator_RowClassName="tblRankRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nRankId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnRankId" msprop:Generator_ColumnPropNameInRow="nRankId" msprop:Generator_ColumnPropNameInTable="nRankIdColumn" msprop:Generator_UserColumnName="nRankId" type="xs:int" />
              <xs:element name="cRankName" msprop:Generator_ColumnVarNameInTable="columncRankName" msprop:Generator_ColumnPropNameInRow="cRankName" msprop:Generator_ColumnPropNameInTable="cRankNameColumn" msprop:Generator_UserColumnName="cRankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankLevel" msprop:Generator_ColumnVarNameInTable="columnnRankLevel" msprop:Generator_ColumnPropNameInRow="nRankLevel" msprop:Generator_ColumnPropNameInTable="nRankLevelColumn" msprop:Generator_UserColumnName="nRankLevel" type="xs:int" minOccurs="0" />
              <xs:element name="cRankDescription" msprop:Generator_ColumnVarNameInTable="columncRankDescription" msprop:Generator_ColumnPropNameInRow="cRankDescription" msprop:Generator_ColumnPropNameInTable="cRankDescriptionColumn" msprop:Generator_UserColumnName="cRankDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iRankType" msprop:Generator_ColumnVarNameInTable="columniRankType" msprop:Generator_ColumnPropNameInRow="iRankType" msprop:Generator_ColumnPropNameInTable="iRankTypeColumn" msprop:Generator_UserColumnName="iRankType" type="xs:int" minOccurs="0" />
              <xs:element name="BasicMonthlyWages" msprop:Generator_ColumnVarNameInTable="columnBasicMonthlyWages" msprop:Generator_ColumnPropNameInRow="BasicMonthlyWages" msprop:Generator_ColumnPropNameInTable="BasicMonthlyWagesColumn" msprop:Generator_UserColumnName="BasicMonthlyWages" type="xs:double" minOccurs="0" />
              <xs:element name="Overtime_x0020_A" msprop:Generator_ColumnVarNameInTable="columnOvertime_A" msprop:Generator_ColumnPropNameInRow="Overtime_A" msprop:Generator_ColumnPropNameInTable="Overtime_AColumn" msprop:Generator_UserColumnName="Overtime A" type="xs:double" minOccurs="0" />
              <xs:element name="Overtime_x0020_B" msprop:Generator_ColumnVarNameInTable="columnOvertime_B" msprop:Generator_ColumnPropNameInRow="Overtime_B" msprop:Generator_ColumnPropNameInTable="Overtime_BColumn" msprop:Generator_UserColumnName="Overtime B" type="xs:double" minOccurs="0" />
              <xs:element name="SubsisAllowence" msprop:Generator_ColumnVarNameInTable="columnSubsisAllowence" msprop:Generator_ColumnPropNameInRow="SubsisAllowence" msprop:Generator_ColumnPropNameInTable="SubsisAllowenceColumn" msprop:Generator_UserColumnName="SubsisAllowence" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCrew" msprop:Generator_TableClassName="tblCrewDataTable" msprop:Generator_TableVarName="tabletblCrew" msprop:Generator_TablePropName="tblCrew" msprop:Generator_RowDeletingName="tblCrewRowDeleting" msprop:Generator_UserTableName="tblCrew" msprop:Generator_RowChangingName="tblCrewRowChanging" msprop:Generator_RowEvHandlerName="tblCrewRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCrewRowDeleted" msprop:Generator_RowEvArgName="tblCrewRowChangeEvent" msprop:Generator_RowChangedName="tblCrewRowChanged" msprop:Generator_RowClassName="tblCrewRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="iCrewType" msprop:Generator_ColumnVarNameInTable="columniCrewType" msprop:Generator_ColumnPropNameInRow="iCrewType" msprop:Generator_ColumnPropNameInTable="iCrewTypeColumn" msprop:Generator_UserColumnName="iCrewType" type="xs:int" minOccurs="0" />
              <xs:element name="bImage" msprop:Generator_ColumnVarNameInTable="columnbImage" msprop:Generator_ColumnPropNameInRow="bImage" msprop:Generator_ColumnPropNameInTable="bImageColumn" msprop:Generator_UserColumnName="bImage" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cCMT" msprop:Generator_ColumnVarNameInTable="columncCMT" msprop:Generator_ColumnPropNameInRow="cCMT" msprop:Generator_ColumnPropNameInTable="cCMTColumn" msprop:Generator_UserColumnName="cCMT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dDateOfBirth" msprop:Generator_ColumnVarNameInTable="columndDateOfBirth" msprop:Generator_ColumnPropNameInRow="dDateOfBirth" msprop:Generator_ColumnPropNameInTable="dDateOfBirthColumn" msprop:Generator_UserColumnName="dDateOfBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cAddress" msprop:Generator_ColumnVarNameInTable="columncAddress" msprop:Generator_ColumnPropNameInRow="cAddress" msprop:Generator_ColumnPropNameInTable="cAddressColumn" msprop:Generator_UserColumnName="cAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHomeNo" msprop:Generator_ColumnVarNameInTable="columncHomeNo" msprop:Generator_ColumnPropNameInRow="cHomeNo" msprop:Generator_ColumnPropNameInTable="cHomeNoColumn" msprop:Generator_UserColumnName="cHomeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHandNo" msprop:Generator_ColumnVarNameInTable="columncHandNo" msprop:Generator_ColumnPropNameInRow="cHandNo" msprop:Generator_ColumnPropNameInTable="cHandNoColumn" msprop:Generator_UserColumnName="cHandNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMaritalStatus" msprop:Generator_ColumnVarNameInTable="columncMaritalStatus" msprop:Generator_ColumnPropNameInRow="cMaritalStatus" msprop:Generator_ColumnPropNameInTable="cMaritalStatusColumn" msprop:Generator_UserColumnName="cMaritalStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cNationality" msprop:Generator_ColumnVarNameInTable="columncNationality" msprop:Generator_ColumnPropNameInRow="cNationality" msprop:Generator_ColumnPropNameInTable="cNationalityColumn" msprop:Generator_UserColumnName="cNationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullName" msdata:ReadOnly="true" msdata:Expression="cFamilyName  +' '+ cMiddleName + ' ' + cFirstName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" type="xs:string" minOccurs="0" />
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="dDuKienRoiTau" msprop:Generator_ColumnVarNameInTable="columndDuKienRoiTau" msprop:Generator_ColumnPropNameInRow="dDuKienRoiTau" msprop:Generator_ColumnPropNameInTable="dDuKienRoiTauColumn" msprop:Generator_UserColumnName="dDuKienRoiTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="onRest" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnonRest" msprop:Generator_ColumnPropNameInRow="onRest" msprop:Generator_ColumnPropNameInTable="onRestColumn" msprop:Generator_UserColumnName="onRest" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblVessel" msprop:Generator_TableClassName="tblVesselDataTable" msprop:Generator_TableVarName="tabletblVessel" msprop:Generator_TablePropName="tblVessel" msprop:Generator_RowDeletingName="tblVesselRowDeleting" msprop:Generator_UserTableName="tblVessel" msprop:Generator_RowChangingName="tblVesselRowChanging" msprop:Generator_RowEvHandlerName="tblVesselRowChangeEventHandler" msprop:Generator_RowDeletedName="tblVesselRowDeleted" msprop:Generator_RowEvArgName="tblVesselRowChangeEvent" msprop:Generator_RowChangedName="tblVesselRowChanged" msprop:Generator_RowClassName="tblVesselRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nVesselId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" />
              <xs:element name="nEngineType" msprop:Generator_ColumnVarNameInTable="columnnEngineType" msprop:Generator_ColumnPropNameInRow="nEngineType" msprop:Generator_ColumnPropNameInTable="nEngineTypeColumn" msprop:Generator_UserColumnName="nEngineType" type="xs:int" minOccurs="0" />
              <xs:element name="nEngineMaker" msprop:Generator_ColumnVarNameInTable="columnnEngineMaker" msprop:Generator_ColumnPropNameInRow="nEngineMaker" msprop:Generator_ColumnPropNameInTable="nEngineMakerColumn" msprop:Generator_UserColumnName="nEngineMaker" type="xs:int" minOccurs="0" />
              <xs:element name="fHorsePower" msprop:Generator_ColumnVarNameInTable="columnfHorsePower" msprop:Generator_ColumnPropNameInRow="fHorsePower" msprop:Generator_ColumnPropNameInTable="fHorsePowerColumn" msprop:Generator_UserColumnName="fHorsePower" type="xs:double" minOccurs="0" />
              <xs:element name="cVesselName" msprop:Generator_ColumnVarNameInTable="columncVesselName" msprop:Generator_ColumnPropNameInRow="cVesselName" msprop:Generator_ColumnPropNameInTable="cVesselNameColumn" msprop:Generator_UserColumnName="cVesselName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cShortName" msprop:Generator_ColumnVarNameInTable="columncShortName" msprop:Generator_ColumnPropNameInRow="cShortName" msprop:Generator_ColumnPropNameInTable="cShortNameColumn" msprop:Generator_UserColumnName="cShortName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nGroupId" msprop:Generator_ColumnVarNameInTable="columnnGroupId" msprop:Generator_ColumnPropNameInRow="nGroupId" msprop:Generator_ColumnPropNameInTable="nGroupIdColumn" msprop:Generator_UserColumnName="nGroupId" type="xs:int" minOccurs="0" />
              <xs:element name="nFlagId" msprop:Generator_ColumnVarNameInTable="columnnFlagId" msprop:Generator_ColumnPropNameInRow="nFlagId" msprop:Generator_ColumnPropNameInTable="nFlagIdColumn" msprop:Generator_UserColumnName="nFlagId" type="xs:int" minOccurs="0" />
              <xs:element name="nVesselTypeId" msprop:Generator_ColumnVarNameInTable="columnnVesselTypeId" msprop:Generator_ColumnPropNameInRow="nVesselTypeId" msprop:Generator_ColumnPropNameInTable="nVesselTypeIdColumn" msprop:Generator_UserColumnName="nVesselTypeId" type="xs:int" minOccurs="0" />
              <xs:element name="fGRT" msprop:Generator_ColumnVarNameInTable="columnfGRT" msprop:Generator_ColumnPropNameInRow="fGRT" msprop:Generator_ColumnPropNameInTable="fGRTColumn" msprop:Generator_UserColumnName="fGRT" type="xs:double" minOccurs="0" />
              <xs:element name="cTradeArea" msprop:Generator_ColumnVarNameInTable="columncTradeArea" msprop:Generator_ColumnPropNameInRow="cTradeArea" msprop:Generator_ColumnPropNameInTable="cTradeAreaColumn" msprop:Generator_UserColumnName="cTradeArea" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cImoNumber" msprop:Generator_ColumnVarNameInTable="columncImoNumber" msprop:Generator_ColumnPropNameInRow="cImoNumber" msprop:Generator_ColumnPropNameInTable="cImoNumberColumn" msprop:Generator_UserColumnName="cImoNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cPortOfRegistry" msprop:Generator_ColumnVarNameInTable="columncPortOfRegistry" msprop:Generator_ColumnPropNameInRow="cPortOfRegistry" msprop:Generator_ColumnPropNameInTable="cPortOfRegistryColumn" msprop:Generator_UserColumnName="cPortOfRegistry" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dYearBuilt" msprop:Generator_ColumnVarNameInTable="columndYearBuilt" msprop:Generator_ColumnPropNameInRow="dYearBuilt" msprop:Generator_ColumnPropNameInTable="dYearBuiltColumn" msprop:Generator_UserColumnName="dYearBuilt" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cVesselManaged" msprop:Generator_ColumnVarNameInTable="columncVesselManaged" msprop:Generator_ColumnPropNameInRow="cVesselManaged" msprop:Generator_ColumnPropNameInTable="cVesselManagedColumn" msprop:Generator_UserColumnName="cVesselManaged" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblLongPlanVessel" msprop:Generator_TableClassName="tblLongPlanVesselDataTable" msprop:Generator_TableVarName="tabletblLongPlanVessel" msprop:Generator_TablePropName="tblLongPlanVessel" msprop:Generator_RowDeletingName="tblLongPlanVesselRowDeleting" msprop:Generator_UserTableName="tblLongPlanVessel" msprop:Generator_RowChangingName="tblLongPlanVesselRowChanging" msprop:Generator_RowEvHandlerName="tblLongPlanVesselRowChangeEventHandler" msprop:Generator_RowDeletedName="tblLongPlanVesselRowDeleted" msprop:Generator_RowEvArgName="tblLongPlanVesselRowChangeEvent" msprop:Generator_RowChangedName="tblLongPlanVesselRowChanged" msprop:Generator_RowClassName="tblLongPlanVesselRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nLongPlanVesselId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnLongPlanVesselId" msprop:Generator_ColumnPropNameInRow="nLongPlanVesselId" msprop:Generator_ColumnPropNameInTable="nLongPlanVesselIdColumn" msprop:Generator_UserColumnName="nLongPlanVesselId" type="xs:int" />
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VesselName" msprop:Generator_ColumnVarNameInTable="columnVesselName" msprop:Generator_ColumnPropNameInRow="VesselName" msprop:Generator_ColumnPropNameInTable="VesselNameColumn" msprop:Generator_UserColumnName="VesselName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dStart" msprop:Generator_ColumnVarNameInTable="columndStart" msprop:Generator_ColumnPropNameInRow="dStart" msprop:Generator_ColumnPropNameInTable="dStartColumn" msprop:Generator_UserColumnName="dStart" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dEnd" msprop:Generator_ColumnVarNameInTable="columndEnd" msprop:Generator_ColumnPropNameInRow="dEnd" msprop:Generator_ColumnPropNameInTable="dEndColumn" msprop:Generator_UserColumnName="dEnd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nRankId" msprop:Generator_ColumnVarNameInTable="columnnRankId" msprop:Generator_ColumnPropNameInRow="nRankId" msprop:Generator_ColumnPropNameInTable="nRankIdColumn" msprop:Generator_UserColumnName="nRankId" type="xs:int" minOccurs="0" />
              <xs:element name="PlanID" msprop:Generator_ColumnVarNameInTable="columnPlanID" msprop:Generator_ColumnPropNameInRow="PlanID" msprop:Generator_ColumnPropNameInTable="PlanIDColumn" msprop:Generator_UserColumnName="PlanID" type="xs:int" minOccurs="0" />
              <xs:element name="ShortName" msprop:Generator_ColumnVarNameInTable="columnShortName" msprop:Generator_ColumnPropNameInRow="ShortName" msprop:Generator_ColumnPropNameInTable="ShortNameColumn" msprop:Generator_UserColumnName="ShortName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nContract" msprop:Generator_ColumnVarNameInTable="columnnContract" msprop:Generator_ColumnPropNameInRow="nContract" msprop:Generator_ColumnPropNameInTable="nContractColumn" msprop:Generator_UserColumnName="nContract" type="xs:int" minOccurs="0" />
              <xs:element name="Subject" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSubject" msprop:Generator_ColumnPropNameInRow="Subject" msprop:Generator_ColumnPropNameInTable="SubjectColumn" msprop:Generator_UserColumnName="Subject" type="xs:string" minOccurs="0" />
              <xs:element name="GroupName" msprop:Generator_ColumnVarNameInTable="columnGroupName" msprop:Generator_ColumnPropNameInRow="GroupName" msprop:Generator_ColumnPropNameInTable="GroupNameColumn" msprop:Generator_UserColumnName="GroupName" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblKeHoach" msprop:Generator_TableClassName="tblKeHoachDataTable" msprop:Generator_TableVarName="tabletblKeHoach" msprop:Generator_TablePropName="tblKeHoach" msprop:Generator_RowDeletingName="tblKeHoachRowDeleting" msprop:Generator_UserTableName="tblKeHoach" msprop:Generator_RowChangingName="tblKeHoachRowChanging" msprop:Generator_RowEvHandlerName="tblKeHoachRowChangeEventHandler" msprop:Generator_RowDeletedName="tblKeHoachRowDeleted" msprop:Generator_RowEvArgName="tblKeHoachRowChangeEvent" msprop:Generator_RowChangedName="tblKeHoachRowChanged" msprop:Generator_RowClassName="tblKeHoachRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Planid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPlanid" msprop:Generator_ColumnPropNameInRow="Planid" msprop:Generator_ColumnPropNameInTable="PlanidColumn" msprop:Generator_UserColumnName="Planid" type="xs:int" />
              <xs:element name="Tên_x0020_kế_x0020_hoạch" msprop:Generator_ColumnVarNameInTable="columnTên_kế_hoạch" msprop:Generator_ColumnPropNameInRow="Tên_kế_hoạch" msprop:Generator_ColumnPropNameInTable="Tên_kế_hoạchColumn" msprop:Generator_UserColumnName="Tên kế hoạch" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Người_x0020_lập_x0020_kế_x0020_hoạch" msprop:Generator_ColumnVarNameInTable="columnNgười_lập_kế_hoạch" msprop:Generator_ColumnPropNameInRow="Người_lập_kế_hoạch" msprop:Generator_ColumnPropNameInTable="Người_lập_kế_hoạchColumn" msprop:Generator_UserColumnName="Người lập kế hoạch" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ngày_x0020_lập_x0020_kế_x0020_hoạch" msprop:Generator_ColumnVarNameInTable="columnNgày_lập_kế_hoạch" msprop:Generator_ColumnPropNameInRow="Ngày_lập_kế_hoạch" msprop:Generator_ColumnPropNameInTable="Ngày_lập_kế_hoạchColumn" msprop:Generator_UserColumnName="Ngày lập kế hoạch" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Ngày_x0020_chỉnh_x0020_sửa" msprop:Generator_ColumnVarNameInTable="columnNgày_chỉnh_sửa" msprop:Generator_ColumnPropNameInRow="Ngày_chỉnh_sửa" msprop:Generator_ColumnPropNameInTable="Ngày_chỉnh_sửaColumn" msprop:Generator_UserColumnName="Ngày chỉnh sửa" type="xs:dateTime" minOccurs="0" />
              <xs:element name="isLongPlan" msprop:Generator_ColumnVarNameInTable="columnisLongPlan" msprop:Generator_ColumnPropNameInRow="isLongPlan" msprop:Generator_ColumnPropNameInTable="isLongPlanColumn" msprop:Generator_UserColumnName="isLongPlan" type="xs:boolean" minOccurs="0" />
              <xs:element name="Mô_x0020_tả" msprop:Generator_ColumnVarNameInTable="columnMô_tả" msprop:Generator_ColumnPropNameInRow="Mô_tả" msprop:Generator_ColumnPropNameInTable="Mô_tảColumn" msprop:Generator_UserColumnName="Mô tả" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Từ" msprop:Generator_ColumnVarNameInTable="columnTừ" msprop:Generator_ColumnPropNameInRow="Từ" msprop:Generator_ColumnPropNameInTable="TừColumn" msprop:Generator_UserColumnName="Từ" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Đến" msprop:Generator_ColumnVarNameInTable="columnĐến" msprop:Generator_ColumnPropNameInRow="Đến" msprop:Generator_ColumnPropNameInTable="ĐếnColumn" msprop:Generator_UserColumnName="Đến" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Đã_x0020_duyệt" msprop:Generator_ColumnVarNameInTable="columnĐã_duyệt" msprop:Generator_ColumnPropNameInRow="Đã_duyệt" msprop:Generator_ColumnPropNameInTable="Đã_duyệtColumn" msprop:Generator_UserColumnName="Đã duyệt" type="xs:boolean" minOccurs="0" />
              <xs:element name="isDone" msprop:Generator_ColumnVarNameInTable="columnisDone" msprop:Generator_ColumnPropNameInRow="isDone" msprop:Generator_ColumnPropNameInTable="isDoneColumn" msprop:Generator_UserColumnName="isDone" type="xs:boolean" minOccurs="0" />
              <xs:element name="NguoiChinhSua" msprop:Generator_ColumnVarNameInTable="columnNguoiChinhSua" msprop:Generator_ColumnPropNameInRow="NguoiChinhSua" msprop:Generator_ColumnPropNameInTable="NguoiChinhSuaColumn" msprop:Generator_UserColumnName="NguoiChinhSua" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblAssignment" msprop:Generator_TableClassName="tblAssignmentDataTable" msprop:Generator_TableVarName="tabletblAssignment" msprop:Generator_TablePropName="tblAssignment" msprop:Generator_RowDeletingName="tblAssignmentRowDeleting" msprop:Generator_UserTableName="tblAssignment" msprop:Generator_RowChangingName="tblAssignmentRowChanging" msprop:Generator_RowEvHandlerName="tblAssignmentRowChangeEventHandler" msprop:Generator_RowDeletedName="tblAssignmentRowDeleted" msprop:Generator_RowEvArgName="tblAssignmentRowChangeEvent" msprop:Generator_RowChangedName="tblAssignmentRowChanged" msprop:Generator_RowClassName="tblAssignmentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nAssignmentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnAssignmentId" msprop:Generator_ColumnPropNameInRow="nAssignmentId" msprop:Generator_ColumnPropNameInTable="nAssignmentIdColumn" msprop:Generator_UserColumnName="nAssignmentId" type="xs:int" />
              <xs:element name="nCrewid" msprop:Generator_ColumnVarNameInTable="columnnCrewid" msprop:Generator_ColumnPropNameInRow="nCrewid" msprop:Generator_ColumnPropNameInTable="nCrewidColumn" msprop:Generator_UserColumnName="nCrewid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dEmbarked" msprop:Generator_ColumnVarNameInTable="columndEmbarked" msprop:Generator_ColumnPropNameInRow="dEmbarked" msprop:Generator_ColumnPropNameInTable="dEmbarkedColumn" msprop:Generator_UserColumnName="dEmbarked" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nContract" msprop:Generator_ColumnVarNameInTable="columnnContract" msprop:Generator_ColumnPropNameInRow="nContract" msprop:Generator_ColumnPropNameInTable="nContractColumn" msprop:Generator_UserColumnName="nContract" type="xs:int" minOccurs="0" />
              <xs:element name="dLeave" msprop:Generator_ColumnVarNameInTable="columndLeave" msprop:Generator_ColumnPropNameInRow="dLeave" msprop:Generator_ColumnPropNameInTable="dLeaveColumn" msprop:Generator_UserColumnName="dLeave" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nRequest" msprop:Generator_ColumnVarNameInTable="columnnRequest" msprop:Generator_ColumnPropNameInRow="nRequest" msprop:Generator_ColumnPropNameInTable="nRequestColumn" msprop:Generator_UserColumnName="nRequest" type="xs:int" minOccurs="0" />
              <xs:element name="dDuKienRoiTau" msprop:Generator_ColumnVarNameInTable="columndDuKienRoiTau" msprop:Generator_ColumnPropNameInRow="dDuKienRoiTau" msprop:Generator_ColumnPropNameInTable="dDuKienRoiTauColumn" msprop:Generator_UserColumnName="dDuKienRoiTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dSanSangLenTau" msprop:Generator_ColumnVarNameInTable="columndSanSangLenTau" msprop:Generator_ColumnPropNameInRow="dSanSangLenTau" msprop:Generator_ColumnPropNameInTable="dSanSangLenTauColumn" msprop:Generator_UserColumnName="dSanSangLenTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dCatHopDong" msprop:Generator_ColumnVarNameInTable="columndCatHopDong" msprop:Generator_ColumnPropNameInRow="dCatHopDong" msprop:Generator_ColumnPropNameInTable="dCatHopDongColumn" msprop:Generator_UserColumnName="dCatHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dNghiHuu" msprop:Generator_ColumnVarNameInTable="columndNghiHuu" msprop:Generator_ColumnPropNameInRow="dNghiHuu" msprop:Generator_ColumnPropNameInTable="dNghiHuuColumn" msprop:Generator_UserColumnName="dNghiHuu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dKyHopDong" msprop:Generator_ColumnVarNameInTable="columndKyHopDong" msprop:Generator_ColumnPropNameInRow="dKyHopDong" msprop:Generator_ColumnPropNameInTable="dKyHopDongColumn" msprop:Generator_UserColumnName="dKyHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dModified" msprop:Generator_ColumnVarNameInTable="columndModified" msprop:Generator_ColumnPropNameInRow="dModified" msprop:Generator_ColumnPropNameInTable="dModifiedColumn" msprop:Generator_UserColumnName="dModified" type="xs:dateTime" minOccurs="0" />
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="cGhiChu" msprop:Generator_ColumnVarNameInTable="columncGhiChu" msprop:Generator_ColumnPropNameInRow="cGhiChu" msprop:Generator_ColumnPropNameInTable="cGhiChuColumn" msprop:Generator_UserColumnName="cGhiChu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblColor" msprop:Generator_TableClassName="tblColorDataTable" msprop:Generator_TableVarName="tabletblColor" msprop:Generator_TablePropName="tblColor" msprop:Generator_RowDeletingName="tblColorRowDeleting" msprop:Generator_UserTableName="tblColor" msprop:Generator_RowChangingName="tblColorRowChanging" msprop:Generator_RowEvHandlerName="tblColorRowChangeEventHandler" msprop:Generator_RowDeletedName="tblColorRowDeleted" msprop:Generator_RowEvArgName="tblColorRowChangeEvent" msprop:Generator_RowChangedName="tblColorRowChanged" msprop:Generator_RowClassName="tblColorRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_UserColumnName="Color" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblVesselGroup" msprop:Generator_TableClassName="tblVesselGroupDataTable" msprop:Generator_TableVarName="tabletblVesselGroup" msprop:Generator_TablePropName="tblVesselGroup" msprop:Generator_RowDeletingName="tblVesselGroupRowDeleting" msprop:Generator_UserTableName="tblVesselGroup" msprop:Generator_RowChangingName="tblVesselGroupRowChanging" msprop:Generator_RowEvHandlerName="tblVesselGroupRowChangeEventHandler" msprop:Generator_RowDeletedName="tblVesselGroupRowDeleted" msprop:Generator_RowEvArgName="tblVesselGroupRowChangeEvent" msprop:Generator_RowChangedName="tblVesselGroupRowChanged" msprop:Generator_RowClassName="tblVesselGroupRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nGroupId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnGroupId" msprop:Generator_ColumnPropNameInRow="nGroupId" msprop:Generator_ColumnPropNameInTable="nGroupIdColumn" msprop:Generator_UserColumnName="nGroupId" type="xs:int" />
              <xs:element name="cGroupName" msprop:Generator_ColumnVarNameInTable="columncGroupName" msprop:Generator_ColumnPropNameInRow="cGroupName" msprop:Generator_ColumnPropNameInTable="cGroupNameColumn" msprop:Generator_UserColumnName="cGroupName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblRank" />
      <xs:field xpath="mstns:nRankId" />
    </xs:unique>
    <xs:unique name="tblCrew_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCrew" />
      <xs:field xpath="mstns:nCrewId" />
    </xs:unique>
    <xs:unique name="tblVessel_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblVessel" />
      <xs:field xpath="mstns:nVesselId" />
    </xs:unique>
    <xs:unique name="tblLongPlanVessel_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblLongPlanVessel" />
      <xs:field xpath="mstns:nLongPlanVesselId" />
    </xs:unique>
    <xs:unique name="tblKeHoach_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblKeHoach" />
      <xs:field xpath="mstns:Planid" />
    </xs:unique>
    <xs:unique name="tblAssignment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblAssignment" />
      <xs:field xpath="mstns:nAssignmentId" />
    </xs:unique>
    <xs:unique name="tblColor_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblColor" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="tblVesselGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblVesselGroup" />
      <xs:field xpath="mstns:nGroupId" />
    </xs:unique>
    <xs:keyref name="FK_tblLongPlanVessel_tblKeHoach" refer="tblKeHoach_Constraint1" msprop:rel_Generator_UserChildTable="tblLongPlanVessel" msprop:rel_Generator_ChildPropName="GettblLongPlanVesselRows" msprop:rel_Generator_UserParentTable="tblKeHoach" msprop:rel_Generator_UserRelationName="FK_tblLongPlanVessel_tblKeHoach1" msprop:rel_Generator_RelationVarName="relationFK_tblLongPlanVessel_tblKeHoach1" msprop:rel_Generator_ParentPropName="tblKeHoachRow" msdata:RelationName="FK_tblLongPlanVessel_tblKeHoach1">
      <xs:selector xpath=".//mstns:tblLongPlanVessel" />
      <xs:field xpath="mstns:PlanID" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblCrew_tblRank" msdata:parent="tblRank" msdata:child="tblCrew" msdata:parentkey="nRankId" msdata:childkey="nRankID" msprop:Generator_UserChildTable="tblCrew" msprop:Generator_ChildPropName="GettblCrewRows" msprop:Generator_UserParentTable="tblRank" msprop:Generator_UserRelationName="FK_tblCrew_tblRank" msprop:Generator_RelationVarName="relationFK_tblCrew_tblRank" msprop:Generator_ParentPropName="tblRankRow" />
      <msdata:Relationship name="FK_tblAssignment_tblVessel" msdata:parent="tblVessel" msdata:child="tblAssignment" msdata:parentkey="nVesselId" msdata:childkey="nVesselId" msprop:Generator_UserChildTable="tblAssignment" msprop:Generator_ChildPropName="GettblAssignmentRows" msprop:Generator_UserParentTable="tblVessel" msprop:Generator_UserRelationName="FK_tblAssignment_tblVessel" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblVessel" msprop:Generator_ParentPropName="tblVesselRow" />
      <msdata:Relationship name="FK_tblVessel_tblVesselGroup" msdata:parent="tblVesselGroup" msdata:child="tblVessel" msdata:parentkey="nGroupId" msdata:childkey="nGroupId" msprop:Generator_UserChildTable="tblVessel" msprop:Generator_ChildPropName="GettblVesselRows" msprop:Generator_UserParentTable="tblVesselGroup" msprop:Generator_UserRelationName="FK_tblVessel_tblVesselGroup" msprop:Generator_RelationVarName="relationFK_tblVessel_tblVesselGroup" msprop:Generator_ParentPropName="tblVesselGroupRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>